<?php return array (
  0 => 'CREATE TABLE `xiaozu_shop` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `uid` int(20) NOT NULL COMMENT \'用户ID\',
  `shortname` varchar(10) DEFAULT NULL COMMENT \'店铺短地址\',
  `shopname` varchar(150) NOT NULL COMMENT \'店铺名称\',
  `shoplogo` varchar(150) DEFAULT NULL,
  `phone` varchar(100) DEFAULT NULL COMMENT \'联系电话\',
  `address` varchar(150) DEFAULT NULL COMMENT \'联系地址\',
  `point` int(10) NOT NULL DEFAULT \'5\' COMMENT \'评分\',
  `cx_info` text COMMENT \'促销信息\',
  `intr_info` text COMMENT \'介绍信息\',
  `notice_info` text COMMENT \'公告信息\',
  `starttime` varchar(100) DEFAULT NULL COMMENT \'营业时间\',
  `is_open` int(1) NOT NULL DEFAULT \'0\' COMMENT \'是否营业\',
  `is_onlinepay` int(1) NOT NULL DEFAULT \'1\' COMMENT \'是否开启在线支付：默认为1开启，0不开启\',
  `is_daopay` int(1) NOT NULL DEFAULT \'1\' COMMENT \'是否开启到付：默认为1开启，0不开启\',
  `is_pass` int(1) NOT NULL DEFAULT \'0\' COMMENT \'是否通过审核\',
  `is_recom` int(1) NOT NULL DEFAULT \'0\' COMMENT \'是否是推荐店铺\',
  `maphone` varchar(12) DEFAULT NULL,
  `addtime` int(12) DEFAULT NULL,
  `pointcount` int(5) NOT NULL DEFAULT \'0\',
  `psservicepoint` int(11) NOT NULL COMMENT \'配送服务评分\',
  `psservicepointcount` int(11) NOT NULL COMMENT \'配送服务评论次数\',
  `yjin` decimal(5,2) NOT NULL DEFAULT \'0.00\' COMMENT \'佣金比例当为0时调用网站设置\',
  `lat` decimal(9,6) NOT NULL DEFAULT \'0.000000\' COMMENT \'地图左坐标\',
  `lng` decimal(9,6) NOT NULL DEFAULT \'0.000000\' COMMENT \'地图右坐标\',
  `shopbacklogo` varchar(255) DEFAULT NULL COMMENT \'商家默认背景图片\',
  `sort` int(20) NOT NULL DEFAULT \'999\' COMMENT \'排序\',
  `email` varchar(50) DEFAULT NULL,
  `areaid1` int(20) NOT NULL DEFAULT \'0\',
  `areaid2` int(20) NOT NULL DEFAULT \'0\',
  `areaid3` int(20) NOT NULL DEFAULT \'0\',
  `otherlink` varchar(255) DEFAULT NULL COMMENT \'其他链接地址\',
  `endtime` int(11) NOT NULL DEFAULT \'0\',
  `IMEI` varchar(255) DEFAULT NULL,
  `shoptype` int(2) NOT NULL DEFAULT \'0\',
  `noticetype` varchar(100) DEFAULT NULL,
  `machine_code` varchar(255) DEFAULT NULL COMMENT \'打印2机器码\',
  `mKey` varchar(255) DEFAULT NULL COMMENT \'打印2打印密匙\',
  `pradiusa` int(1) NOT NULL DEFAULT \'1\',
  `admin_id` int(20) NOT NULL DEFAULT \'0\',
  `sellcount` int(10) DEFAULT \'0\',
  `goodattrdefault` varchar(25) NOT NULL,
  `ruzhutype` int(11) NOT NULL DEFAULT \'0\',
  `qiyeimg` varchar(150) NOT NULL,
  `zmimg` varchar(150) NOT NULL,
  `fmimg` varchar(150) NOT NULL,
  `foodtongimg` varchar(150) DEFAULT NULL,
  `jkzimg` varchar(150) DEFAULT NULL,
  `sqimg` varchar(150) DEFAULT NULL,
  `qtshuoming` varchar(255) DEFAULT NULL,
  `wxhui_ewmurl` text NOT NULL COMMENT \'闪惠制作二维码url\',
  `goodlistmodule` int(1) NOT NULL DEFAULT \'0\' COMMENT \'商品列表模板默认为0   \',
  `shoplicense` varchar(150) NOT NULL COMMENT \'营业执照\',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=199 DEFAULT CHARSET=utf8',
  1 => 'INSERT INTO `xiaozu_shop`(`id`,`uid`,`shortname`,`shopname`,`shoplogo`,`phone`,`address`,`point`,`cx_info`,`intr_info`,`notice_info`,`starttime`,`is_open`,`is_onlinepay`,`is_daopay`,`is_pass`,`is_recom`,`maphone`,`addtime`,`pointcount`,`psservicepoint`,`psservicepointcount`,`yjin`,`lat`,`lng`,`shopbacklogo`,`sort`,`email`,`areaid1`,`areaid2`,`areaid3`,`otherlink`,`endtime`,`IMEI`,`shoptype`,`noticetype`,`machine_code`,`mKey`,`pradiusa`,`admin_id`,`sellcount`,`goodattrdefault`,`ruzhutype`,`qiyeimg`,`zmimg`,`fmimg`,`foodtongimg`,`jkzimg`,`sqimg`,`qtshuoming`,`wxhui_ewmurl`,`goodlistmodule`,`shoplicense`) VALUES(\'4\',\'4\',\'www.hlju\',\'新区美格美得百货商行\',\'/upload/user/20160109232216756.jpg\',\'18626399933\',\'无锡\',\'5\',\'\',\'\',\'本店为测试店，请勿购买\',\'07:00-12:59|13:00-24:00\',\'1\',\'1\',\'1\',\'1\',\'1\',\'18626399933\',\'1433149257\',\'1\',\'5\',\'1\',\'5.00\',\'31.563956\',\'120.369449\',\'\',\'1\',\'563096011@qq.com\',\'0\',\'0\',\'0\',\'\',\'1480433306\',\'\',\'0\',\'1,2,3\',\'\',\'\',\'5\',\'0\',\'396\',\'件\',\'0\',\'\',\'\',\'\',\'\',\'\',\'\',\'\',\'\',\'0\',\'\')',
  2 => 'INSERT INTO `xiaozu_shop`(`id`,`uid`,`shortname`,`shopname`,`shoplogo`,`phone`,`address`,`point`,`cx_info`,`intr_info`,`notice_info`,`starttime`,`is_open`,`is_onlinepay`,`is_daopay`,`is_pass`,`is_recom`,`maphone`,`addtime`,`pointcount`,`psservicepoint`,`psservicepointcount`,`yjin`,`lat`,`lng`,`shopbacklogo`,`sort`,`email`,`areaid1`,`areaid2`,`areaid3`,`otherlink`,`endtime`,`IMEI`,`shoptype`,`noticetype`,`machine_code`,`mKey`,`pradiusa`,`admin_id`,`sellcount`,`goodattrdefault`,`ruzhutype`,`qiyeimg`,`zmimg`,`fmimg`,`foodtongimg`,`jkzimg`,`sqimg`,`qtshuoming`,`wxhui_ewmurl`,`goodlistmodule`,`shoplicense`) VALUES(\'190\',\'2955\',\'heshe\',\'合硕厨卫电器\',\'/upload/user/20160416225805987.png\',\'13391106993\',\'青海省地址：西宁市城东区互助路小商品市场2期2楼45号\',\'5\',\'\',\'\',\'\',\'08:30-11:59|12:00-18:30\',\'1\',\'1\',\'1\',\'1\',\'1\',\'13391106993\',\'1460466166\',\'1\',\'5\',\'1\',\'0.00\',\'36.619091\',\'101.826368\',\'\',\'999\',\'wzhysp@126.com\',\'0\',\'0\',\'0\',\'\',\'1486441471\',\'\',\'1\',\'\',\'\',\'\',\'30\',\'89\',\'0\',\'台\',\'1\',\'/upload/goods/20160412210120913.jpg\',\'/upload/goods/20160412210138167.jpg\',\'/upload/goods/20160412210202666.jpg\',\'/upload/goods/20160412210243738.jpg\',\'\',\'\',\'\',\'\',\'1\',\'\')',
  3 => 'INSERT INTO `xiaozu_shop`(`id`,`uid`,`shortname`,`shopname`,`shoplogo`,`phone`,`address`,`point`,`cx_info`,`intr_info`,`notice_info`,`starttime`,`is_open`,`is_onlinepay`,`is_daopay`,`is_pass`,`is_recom`,`maphone`,`addtime`,`pointcount`,`psservicepoint`,`psservicepointcount`,`yjin`,`lat`,`lng`,`shopbacklogo`,`sort`,`email`,`areaid1`,`areaid2`,`areaid3`,`otherlink`,`endtime`,`IMEI`,`shoptype`,`noticetype`,`machine_code`,`mKey`,`pradiusa`,`admin_id`,`sellcount`,`goodattrdefault`,`ruzhutype`,`qiyeimg`,`zmimg`,`fmimg`,`foodtongimg`,`jkzimg`,`sqimg`,`qtshuoming`,`wxhui_ewmurl`,`goodlistmodule`,`shoplicense`) VALUES(\'103\',\'1112\',\'1141\',\'光合超市旗舰店\',\'/upload/user/20160109232632948.jpg\',\'15022222222\',\'冉屯北路13号27号楼一层附9号\',\'5\',\'\',\'\',\'外卖人8.0发布上线！持续升级永无止境！\',\'00:01-23:59\',\'1\',\'1\',\'1\',\'1\',\'1\',\'15555554444\',\'1442311583\',\'1\',\'5\',\'1\',\'5.00\',\'34.802461\',\'113.597715\',\'\',\'2\',\'56465@qq.com\',\'0\',\'0\',\'0\',\'\',\'1473847583\',\'\',\'1\',\'1,2,3\',\'\',\'\',\'10\',\'67\',\'12\',\'份\',\'0\',\'\',\'\',\'\',\'\',\'\',\'\',\'\',\'\',\'1\',\'\')',
  4 => 'INSERT INTO `xiaozu_shop`(`id`,`uid`,`shortname`,`shopname`,`shoplogo`,`phone`,`address`,`point`,`cx_info`,`intr_info`,`notice_info`,`starttime`,`is_open`,`is_onlinepay`,`is_daopay`,`is_pass`,`is_recom`,`maphone`,`addtime`,`pointcount`,`psservicepoint`,`psservicepointcount`,`yjin`,`lat`,`lng`,`shopbacklogo`,`sort`,`email`,`areaid1`,`areaid2`,`areaid3`,`otherlink`,`endtime`,`IMEI`,`shoptype`,`noticetype`,`machine_code`,`mKey`,`pradiusa`,`admin_id`,`sellcount`,`goodattrdefault`,`ruzhutype`,`qiyeimg`,`zmimg`,`fmimg`,`foodtongimg`,`jkzimg`,`sqimg`,`qtshuoming`,`wxhui_ewmurl`,`goodlistmodule`,`shoplicense`) VALUES(\'198\',\'2970\',\'nxy\',\'鸿运超市\',\'\',\'13771482868\',\'硕放镇南星苑菜市场\',\'5\',\'\',\'\',\'\',\'7:00-11:59|12:00-9:30\',\'1\',\'1\',\'1\',\'1\',\'0\',\'13921512466\',\'1461555244\',\'0\',\'0\',\'0\',\'0.00\',\'31.476969\',\'120.444086\',\'\',\'999\',\'12345@qq.com\',\'0\',\'0\',\'0\',\'\',\'1493091244\',\'\',\'1\',\'\',\'\',\'\',\'3\',\'0\',\'0\',\'个\',\'0\',\'\',\'\',\'\',\'\',\'\',\'\',\'\',\'\',\'1\',\'\')',
  5 => 'INSERT INTO `xiaozu_shop`(`id`,`uid`,`shortname`,`shopname`,`shoplogo`,`phone`,`address`,`point`,`cx_info`,`intr_info`,`notice_info`,`starttime`,`is_open`,`is_onlinepay`,`is_daopay`,`is_pass`,`is_recom`,`maphone`,`addtime`,`pointcount`,`psservicepoint`,`psservicepointcount`,`yjin`,`lat`,`lng`,`shopbacklogo`,`sort`,`email`,`areaid1`,`areaid2`,`areaid3`,`otherlink`,`endtime`,`IMEI`,`shoptype`,`noticetype`,`machine_code`,`mKey`,`pradiusa`,`admin_id`,`sellcount`,`goodattrdefault`,`ruzhutype`,`qiyeimg`,`zmimg`,`fmimg`,`foodtongimg`,`jkzimg`,`sqimg`,`qtshuoming`,`wxhui_ewmurl`,`goodlistmodule`,`shoplicense`) VALUES(\'196\',\'2964\',\'xycs\',\'学友超市\',\'\',\'18626399933\',\'无锡市职教园\',\'5\',\'\',\'\',\'\',\'7:30-12:00|12:01-22:00\',\'1\',\'1\',\'1\',\'1\',\'0\',\'18626399933\',\'1460888444\',\'0\',\'0\',\'0\',\'0.00\',\'31.588621\',\'120.195192\',\'\',\'999\',\'563096011@qq.com\',\'0\',\'0\',\'0\',\'\',\'1492424444\',\'\',\'1\',\'\',\'\',\'\',\'1\',\'0\',\'0\',\'份\',\'0\',\'\',\'\',\'\',\'\',\'\',\'\',\'\',\'\',\'1\',\'\')',
  6 => 'INSERT INTO `xiaozu_shop`(`id`,`uid`,`shortname`,`shopname`,`shoplogo`,`phone`,`address`,`point`,`cx_info`,`intr_info`,`notice_info`,`starttime`,`is_open`,`is_onlinepay`,`is_daopay`,`is_pass`,`is_recom`,`maphone`,`addtime`,`pointcount`,`psservicepoint`,`psservicepointcount`,`yjin`,`lat`,`lng`,`shopbacklogo`,`sort`,`email`,`areaid1`,`areaid2`,`areaid3`,`otherlink`,`endtime`,`IMEI`,`shoptype`,`noticetype`,`machine_code`,`mKey`,`pradiusa`,`admin_id`,`sellcount`,`goodattrdefault`,`ruzhutype`,`qiyeimg`,`zmimg`,`fmimg`,`foodtongimg`,`jkzimg`,`sqimg`,`qtshuoming`,`wxhui_ewmurl`,`goodlistmodule`,`shoplicense`) VALUES(\'197\',\'2965\',\'sydx\',\'沈大学友\',\'\',\'18627691909\',\'沈阳大学\',\'5\',\'\',\'\',\'\',\'7:30-12:00|12:01-23:00\',\'0\',\'1\',\'1\',\'1\',\'0\',\'18627691909\',\'1460935191\',\'0\',\'0\',\'0\',\'0.00\',\'41.832420\',\'123.466918\',\'\',\'999\',\'970268691@qq.com\',\'0\',\'0\',\'0\',\'\',\'1492471191\',\'\',\'1\',\'\',\'\',\'\',\'2\',\'0\',\'0\',\'份\',\'0\',\'\',\'\',\'\',\'\',\'\',\'\',\'\',\'\',\'0\',\'\')',
)?>